object WebModule1: TWebModule1
  OldCreateOrder = False
  Actions = <
    item
      Default = True
      Name = 'DefaultHandler'
      PathInfo = '/'
      OnAction = WebModule1DefaultHandlerAction
    end>
  Height = 816
  Width = 1356
  object HTTPSoapDispatcher1: THTTPSoapDispatcher
    Dispatcher = HTTPSoapPascalInvoker1
    WebDispatch.PathInfo = 'soap*'
    Left = 60
    Top = 11
  end
  object HTTPSoapPascalInvoker1: THTTPSoapPascalInvoker
    Converter.Options = [soSendMultiRefObj, soTryAllSchema, soUTF8InHeader]
    Left = 60
    Top = 67
  end
  object WSDLHTMLPublish1: TWSDLHTMLPublish
    WebDispatch.MethodType = mtAny
    WebDispatch.PathInfo = 'wsdl*'
    TargetNamespace = 'http://tempuri.org/'
    PublishOptions = [poUTF8ContentType]
    Left = 60
    Top = 123
  end
  object FDQuery1: TFDQuery
    Connection = FDConnection1
    SQL.Strings = (
      'select * from bmgriddisp')
    Left = 384
    Top = 32
  end
  object ClientDataSet1: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'DataSetProvider1'
    Left = 464
    Top = 32
    object ClientDataSet1id: TAutoIncField
      FieldName = 'id'
      ReadOnly = True
    end
    object ClientDataSet1orgzdmc: TWideStringField
      FieldName = 'orgzdmc'
      Required = True
      Size = 50
    end
    object ClientDataSet1displabel: TWideStringField
      FieldName = 'displabel'
      Size = 50
    end
    object ClientDataSet1dispwidth: TSmallintField
      FieldName = 'dispwidth'
    end
  end
  object FDConnection1: TFDConnection
    Params.Strings = (
      'User_Name=sa'
      'Password=7891165'
      'Server=192.168.2.119'
      'Database=GDZC_Bak'
      'DriverID=MSSQL')
    LoginPrompt = False
    Left = 216
    Top = 32
  end
  object DataSetProvider1: TDataSetProvider
    DataSet = FDQuery1
    Left = 304
    Top = 32
  end
  object FDConnection2: TFDConnection
    Params.Strings = (
      'Database=cw'
      'User_Name=root'
      'Password=Wjzh2019'
      'Server=110.185.107.182'
      'CharacterSet=gbk'
      'DriverID=MySQL')
    LoginPrompt = False
    Left = 200
    Top = 104
  end
  object DataSetProvider2: TDataSetProvider
    DataSet = FDQuery2
    Left = 288
    Top = 104
  end
  object FDQuery2: TFDQuery
    Connection = FDConnection2
    SQL.Strings = (
      'select * from ck_user where yhm= :yhm')
    Left = 368
    Top = 104
    ParamData = <
      item
        Name = 'YHM'
        ParamType = ptInput
      end>
  end
  object ClientDataSet2: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'DataSetProvider2'
    Left = 448
    Top = 104
    object ClientDataSet2id: TAutoIncField
      FieldName = 'id'
      ReadOnly = True
    end
    object ClientDataSet2yhm: TWideStringField
      FieldName = 'yhm'
      Size = 50
    end
    object ClientDataSet2yhmm: TWideStringField
      FieldName = 'yhmm'
      Size = 50
    end
    object ClientDataSet2yhzt: TWideStringField
      FieldName = 'yhzt'
    end
    object ClientDataSet2yzm: TWideStringField
      FieldName = 'yzm'
    end
    object ClientDataSet2bz: TWideStringField
      FieldName = 'bz'
      Size = 100
    end
  end
  object DataSetProvider3: TDataSetProvider
    DataSet = FDQuery3
    Left = 56
    Top = 192
  end
  object FDQuery3: TFDQuery
    Connection = FDConnection2
    SQL.Strings = (
      'select * from driver where 1=2')
    Left = 136
    Top = 192
  end
  object ClientDataSet3: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'DataSetProvider3'
    Left = 216
    Top = 192
    object ClientDataSet3dr_id: TAutoIncField
      FieldName = 'dr_id'
      ReadOnly = True
    end
    object ClientDataSet3dr_name: TStringField
      FieldName = 'dr_name'
      Size = 50
    end
    object ClientDataSet3password: TStringField
      FieldName = 'password'
      Size = 32
    end
    object ClientDataSet3salt: TStringField
      FieldName = 'salt'
      Size = 6
    end
    object ClientDataSet3openid: TStringField
      FieldName = 'openid'
      Size = 30
    end
    object ClientDataSet3phone: TStringField
      FieldName = 'phone'
      Size = 50
    end
    object ClientDataSet3city: TIntegerField
      FieldName = 'city'
    end
    object ClientDataSet3salary: TBCDField
      FieldName = 'salary'
      Precision = 10
      Size = 2
    end
    object ClientDataSet3img: TStringField
      FieldName = 'img'
      Size = 255
    end
    object ClientDataSet3add_time: TDateTimeField
      FieldName = 'add_time'
    end
    object ClientDataSet3uid: TStringField
      FieldName = 'uid'
      Size = 510
    end
  end
  object DataSetProvider4: TDataSetProvider
    DataSet = FDQuery4
    Left = 48
    Top = 264
  end
  object FDQuery4: TFDQuery
    Connection = FDConnection2
    SQL.Strings = (
      'select  *  from chegnshi ')
    Left = 128
    Top = 264
  end
  object chengshi: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'DataSetProvider4'
    Left = 208
    Top = 264
    object chengshiid: TAutoIncField
      FieldName = 'id'
      ReadOnly = True
    end
    object chengshicsbh: TWideStringField
      FieldName = 'csbh'
      Size = 50
    end
    object chengshicsmc: TWideStringField
      FieldName = 'csmc'
      Size = 50
    end
  end
  object DataSetProvider5: TDataSetProvider
    DataSet = FDQuery5
    Left = 48
    Top = 344
  end
  object FDQuery5: TFDQuery
    Connection = FDConnection2
    SQL.Strings = (
      
        'select ww.*,bb.station_name as endname from  (select a.*,b.stati' +
        'on_name as startname '
      
        'from (select *  from line) a LEFT JOIN station b on a.start=b.st' +
        '_id) ww'
      'LEFT JOIN station bb on ww.end=bb.st_id ')
    Left = 128
    Top = 344
  end
  object changjianwenti: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'DataSetProvider5'
    Left = 208
    Top = 344
    object changjianwentiline_id: TLongWordField
      FieldName = 'line_id'
    end
    object changjianwentiline_name: TStringField
      FieldName = 'line_name'
      Size = 510
    end
    object changjianwentistart: TIntegerField
      FieldName = 'start'
    end
    object changjianwentiend: TIntegerField
      FieldName = 'end'
    end
    object changjianwentipass: TStringField
      FieldName = 'pass'
      Size = 510
    end
    object changjianwentiscence_id: TIntegerField
      FieldName = 'scence_id'
    end
    object changjianwenticity: TIntegerField
      FieldName = 'city'
    end
    object changjianwentireward: TBCDField
      FieldName = 'reward'
      Precision = 10
      Size = 2
    end
    object changjianwentiremark: TStringField
      FieldName = 'remark'
      Size = 510
    end
    object changjianwentisort: TIntegerField
      FieldName = 'sort'
    end
    object changjianwenticompany_id: TIntegerField
      FieldName = 'company_id'
    end
    object changjianwentistatus: TBooleanField
      FieldName = 'status'
    end
    object changjianwentistartname: TStringField
      FieldName = 'startname'
      ReadOnly = True
      Size = 100
    end
    object changjianwentiendname: TStringField
      FieldName = 'endname'
      ReadOnly = True
      Size = 100
    end
  end
  object chepiao: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'DataSetProvider6'
    Left = 208
    Top = 432
    object chepiaooil_id: TAutoIncField
      FieldName = 'oil_id'
      ReadOnly = True
    end
    object chepiaoplate: TStringField
      FieldName = 'plate'
      Size = 50
    end
    object chepiaodriver_id: TIntegerField
      FieldName = 'driver_id'
    end
    object chepiaoodd_number: TStringField
      FieldName = 'odd_number'
      Size = 255
    end
    object chepiaooil_l: TBCDField
      FieldName = 'oil_l'
      Precision = 10
      Size = 2
    end
    object chepiaooil_fee: TBCDField
      FieldName = 'oil_fee'
      Precision = 10
      Size = 2
    end
    object chepiaohanddle: TStringField
      FieldName = 'handdle'
      Size = 50
    end
    object chepiaoremark: TStringField
      FieldName = 'remark'
      Size = 255
    end
    object chepiaooil_type: TBooleanField
      FieldName = 'oil_type'
    end
    object chepiaooil_time: TStringField
      FieldName = 'oil_time'
      Size = 510
    end
    object chepiaoadd_time: TStringField
      FieldName = 'add_time'
      Size = 510
    end
    object chepiaostatus: TBooleanField
      FieldName = 'status'
    end
    object chepiaoadd: TStringField
      FieldName = 'add'
      Size = 510
    end
    object chepiaokmnumber: TStringField
      FieldName = 'kmnumber'
      Size = 510
    end
  end
  object FDQuery6: TFDQuery
    Connection = FDConnection2
    SQL.Strings = (
      'select * from oil_record')
    Left = 128
    Top = 432
  end
  object DataSetProvider6: TDataSetProvider
    DataSet = FDQuery6
    Left = 32
    Top = 432
  end
  object DataSetProvider7: TDataSetProvider
    DataSet = FDQuery7
    Left = 32
    Top = 512
  end
  object FDQuery7: TFDQuery
    Connection = FDConnection2
    SQL.Strings = (
      
        'select * from line_station a left join station b on a.station_id' +
        '=b.st_id where  a.line_id='#39'1'#39)
    Left = 128
    Top = 512
  end
  object xianlushenqing: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'DataSetProvider7'
    Left = 208
    Top = 512
    object xianlushenqingls_id: TAutoIncField
      FieldName = 'ls_id'
      ReadOnly = True
    end
    object xianlushenqingline_id: TIntegerField
      FieldName = 'line_id'
      Required = True
    end
    object xianlushenqingstation_id: TLongWordField
      FieldName = 'station_id'
    end
    object xianlushenqingdiff_time: TIntegerField
      FieldName = 'diff_time'
    end
    object xianlushenqingdiff_distance: TStringField
      FieldName = 'diff_distance'
      Size = 100
    end
    object xianlushenqingsort: TIntegerField
      FieldName = 'sort'
    end
    object xianlushenqingst_id: TLongWordField
      FieldName = 'st_id'
      ReadOnly = True
    end
    object xianlushenqingstation_name: TStringField
      FieldName = 'station_name'
      ReadOnly = True
      Size = 100
    end
    object xianlushenqingshort_name: TStringField
      FieldName = 'short_name'
      ReadOnly = True
    end
    object xianlushenqinglonglat_bd: TStringField
      FieldName = 'longlat_bd'
      ReadOnly = True
      Size = 510
    end
    object xianlushenqinglonglat_gd: TStringField
      FieldName = 'longlat_gd'
      ReadOnly = True
      Size = 510
    end
    object xianlushenqingradius: TIntegerField
      FieldName = 'radius'
      ReadOnly = True
    end
    object xianlushenqingcity: TIntegerField
      FieldName = 'city'
      ReadOnly = True
    end
    object xianlushenqingaddress: TStringField
      FieldName = 'address'
      ReadOnly = True
      Size = 510
    end
    object xianlushenqingsign_img: TStringField
      FieldName = 'sign_img'
      ReadOnly = True
      Size = 510
    end
    object xianlushenqingtype: TBooleanField
      FieldName = 'type'
      ReadOnly = True
    end
    object xianlushenqingcompany_id: TIntegerField
      FieldName = 'company_id'
      ReadOnly = True
    end
    object xianlushenqingsort_1: TIntegerField
      FieldName = 'sort_1'
      ReadOnly = True
    end
  end
  object DataSetProvider8: TDataSetProvider
    DataSet = FDQuery8
    Left = 32
    Top = 584
  end
  object FDQuery8: TFDQuery
    Connection = FDConnection2
    SQL.Strings = (
      
        ' select zz.*,mm.short_name as lineend,mm.longlat_gd as endgd,mm.' +
        'longlat_bd as endbd,mm.radius as daodaradius from '
      
        '     (select ww.*,dd.station_name as linestar,dd.longlat_gd as s' +
        'targd,dd.longlat_bd as starbd,dd.radius as chufaradius from'
      
        ' (select a.sch_id,a.day,a.plate,a.driver_id,a.line_id,a.depart_t' +
        'ime,a.interpreter,a.checkman,'
      
        'a.scroll,a.city,a.real_depart_time,a.real_depart_lnglat,a.real_e' +
        'nd_time,a.real_end_lnglat,a.depart_status,a.end_status,'
      
        'a.inter_depart_time,a.inter_end_time,a.depart_inter_status,a.end' +
        '_inter_status,a.sale_seat,a.total_seat-a.sale_seat as surplus_se' +
        'at,a.lock_seat,a.total_seat,'
      
        'a.remark,a.status,a.state,a.real_depart_lnglat_jj,a.real_end_lng' +
        'lat_jj,b.in_name,b.phone,c.start,c.end   '
      
        ' from car_sch a left join interpreter b on a.interpreter=b.in_id' +
        ' left join line c on a.line_id=c.line_id  where '
      
        ' a.driver_id='#39'1'#39' and a.day='#39'2019-03-27'#39' order by day desc) ww le' +
        'ft join station dd on ww.`start`=dd.st_id) zz left join '
      ' station mm on zz.end=mm.st_id ')
    Left = 128
    Top = 584
  end
  object zaixianfankui: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'DataSetProvider8'
    Left = 208
    Top = 584
    object zaixianfankuiday: TDateField
      FieldName = 'day'
    end
    object zaixianfankuiplate: TStringField
      FieldName = 'plate'
      Size = 100
    end
    object zaixianfankuidriver_id: TIntegerField
      FieldName = 'driver_id'
    end
    object zaixianfankuiline_id: TIntegerField
      FieldName = 'line_id'
    end
    object zaixianfankuidepart_time: TStringField
      FieldName = 'depart_time'
      Size = 40
    end
    object zaixianfankuiinterpreter: TStringField
      FieldName = 'interpreter'
      Size = 100
    end
    object zaixianfankuicheckman: TStringField
      FieldName = 'checkman'
      Size = 100
    end
    object zaixianfankuiscroll: TBooleanField
      FieldName = 'scroll'
    end
    object zaixianfankuicity: TIntegerField
      FieldName = 'city'
    end
    object zaixianfankuireal_depart_time: TStringField
      FieldName = 'real_depart_time'
      Size = 40
    end
    object zaixianfankuireal_depart_lnglat: TStringField
      FieldName = 'real_depart_lnglat'
      Size = 510
    end
    object zaixianfankuireal_end_time: TStringField
      FieldName = 'real_end_time'
      Size = 40
    end
    object zaixianfankuireal_end_lnglat: TStringField
      FieldName = 'real_end_lnglat'
      Size = 510
    end
    object zaixianfankuidepart_status: TIntegerField
      FieldName = 'depart_status'
    end
    object zaixianfankuiend_status: TIntegerField
      FieldName = 'end_status'
    end
    object zaixianfankuilock_seat: TByteField
      FieldName = 'lock_seat'
    end
    object zaixianfankuitotal_seat: TByteField
      FieldName = 'total_seat'
    end
    object zaixianfankuiremark: TStringField
      FieldName = 'remark'
      Size = 510
    end
    object zaixianfankuistatus: TBooleanField
      FieldName = 'status'
    end
    object zaixianfankuistate: TStringField
      FieldName = 'state'
      Size = 510
    end
    object zaixianfankuiin_name: TStringField
      FieldName = 'in_name'
      ReadOnly = True
      Size = 100
    end
    object zaixianfankuiphone: TStringField
      FieldName = 'phone'
      ReadOnly = True
      Size = 100
    end
    object zaixianfankuistart: TIntegerField
      FieldName = 'start'
      ReadOnly = True
    end
    object zaixianfankuiend: TIntegerField
      FieldName = 'end'
      ReadOnly = True
    end
    object zaixianfankuilinestar: TStringField
      FieldName = 'linestar'
      ReadOnly = True
      Size = 100
    end
    object zaixianfankuistargd: TStringField
      FieldName = 'stargd'
      ReadOnly = True
      Size = 510
    end
    object zaixianfankuistarbd: TStringField
      FieldName = 'starbd'
      ReadOnly = True
      Size = 510
    end
    object zaixianfankuilineend: TStringField
      FieldName = 'lineend'
      ReadOnly = True
    end
    object zaixianfankuiendgd: TStringField
      FieldName = 'endgd'
      ReadOnly = True
      Size = 510
    end
    object zaixianfankuiendbd: TStringField
      FieldName = 'endbd'
      ReadOnly = True
      Size = 510
    end
    object zaixianfankuisch_id: TAutoIncField
      FieldName = 'sch_id'
      ReadOnly = True
    end
    object zaixianfankuiinter_depart_time: TStringField
      FieldName = 'inter_depart_time'
      Size = 40
    end
    object zaixianfankuiinter_end_time: TStringField
      FieldName = 'inter_end_time'
      Size = 40
    end
    object zaixianfankuidepart_inter_status: TIntegerField
      FieldName = 'depart_inter_status'
    end
    object zaixianfankuiend_inter_status: TIntegerField
      FieldName = 'end_inter_status'
    end
    object zaixianfankuireal_depart_lnglat_jj: TStringField
      FieldName = 'real_depart_lnglat_jj'
      Size = 510
    end
    object zaixianfankuireal_end_lnglat_jj: TStringField
      FieldName = 'real_end_lnglat_jj'
      Size = 510
    end
    object zaixianfankuichufaradius: TIntegerField
      FieldName = 'chufaradius'
    end
    object zaixianfankuidaodaradius: TIntegerField
      FieldName = 'daodaradius'
    end
    object zaixianfankuisale_seat: TByteField
      FieldName = 'sale_seat'
    end
    object zaixianfankuisurplus_seat: TLargeintField
      FieldName = 'surplus_seat'
    end
  end
  object DataSetProvider9: TDataSetProvider
    DataSet = FDQuery9
    Left = 360
    Top = 200
  end
  object FDQuery9: TFDQuery
    Connection = FDConnection2
    SQL.Strings = (
      'select * from huodongzhongxin')
    Left = 456
    Top = 200
  end
  object huodongzhongxin: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'DataSetProvider9'
    Left = 536
    Top = 200
    object huodongzhongxinid: TAutoIncField
      FieldName = 'id'
      ReadOnly = True
    end
    object huodongzhongxinhdbh: TWideStringField
      FieldName = 'hdbh'
      Size = 50
    end
    object huodongzhongxinhdmc: TWideStringField
      FieldName = 'hdmc'
      FixedChar = True
      Size = 50
    end
    object huodongzhongxinhdnr: TWideStringField
      FieldName = 'hdnr'
      Size = 500
    end
    object huodongzhongxinsffsdx: TWideStringField
      FieldName = 'sffsdx'
      Size = 50
    end
    object huodongzhongxintplj: TWideStringField
      FieldName = 'tplj'
      Size = 50
    end
    object huodongzhongxinxtlj: TWideStringField
      FieldName = 'xtlj'
      Size = 50
    end
  end
  object DataSetProvider10: TDataSetProvider
    DataSet = FDQuery10
    Left = 360
    Top = 280
  end
  object FDQuery10: TFDQuery
    Connection = FDConnection2
    SQL.Strings = (
      'select * from xianlubiao')
    Left = 456
    Top = 280
  end
  object xianlubiao: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'DataSetProvider10'
    Left = 536
    Top = 280
    object xianlubiaoid: TAutoIncField
      FieldName = 'id'
      ReadOnly = True
    end
    object xianlubiaoxlbh: TWideStringField
      FieldName = 'xlbh'
      Size = 50
    end
    object xianlubiaoxlmc: TWideStringField
      FieldName = 'xlmc'
      Size = 50
    end
    object xianlubiaoxlqsz: TWideStringField
      FieldName = 'xlqsz'
      Size = 50
    end
    object xianlubiaoxlzdz: TWideStringField
      FieldName = 'xlzdz'
      Size = 50
    end
    object xianlubiaoxljg: TWideStringField
      FieldName = 'xljg'
    end
    object xianlubiaofcsj: TWideStringField
      FieldName = 'fcsj'
      Size = 50
    end
    object xianlubiaoddsj: TWideStringField
      FieldName = 'ddsj'
      Size = 50
    end
    object xianlubiaoxlpj: TWideStringField
      FieldName = 'xlpj'
      Size = 50
    end
    object xianlubiaosfqyxlpj: TWideStringField
      FieldName = 'sfqyxlpj'
      Size = 50
    end
    object xianlubiaomzrs: TWideStringField
      FieldName = 'mzrs'
      Size = 50
    end
    object xianlubiaocph: TWideStringField
      FieldName = 'cph'
      Size = 50
    end
    object xianlubiaoclzt: TWideStringField
      FieldName = 'clzt'
      Size = 50
    end
    object xianlubiaocs: TWideStringField
      FieldName = 'cs'
      Size = 50
    end
    object xianlubiaotype: TWideStringField
      FieldName = 'type'
      Size = 50
    end
  end
  object DataSetProvider11: TDataSetProvider
    DataSet = FDQuery11
    Left = 368
    Top = 368
  end
  object FDQuery11: TFDQuery
    Connection = FDConnection2
    SQL.Strings = (
      'select * from xianlubiaozibiao')
    Left = 464
    Top = 368
  end
  object xianlubiaozibiao: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'DataSetProvider11'
    Left = 544
    Top = 368
    object xianlubiaozibiaoid: TAutoIncField
      FieldName = 'id'
      ReadOnly = True
    end
    object xianlubiaozibiaoxlbh: TWideStringField
      FieldName = 'xlbh'
      Size = 50
    end
    object xianlubiaozibiaozmc: TWideStringField
      FieldName = 'zmc'
      Size = 50
    end
    object xianlubiaozibiaojd: TWideStringField
      FieldName = 'jd'
      Size = 50
    end
    object xianlubiaozibiaowd: TWideStringField
      FieldName = 'wd'
      Size = 50
    end
    object xianlubiaozibiaodzsj: TWideStringField
      FieldName = 'dzsj'
      Size = 50
    end
    object xianlubiaozibiaobz: TWideStringField
      FieldName = 'bz'
      Size = 50
    end
    object xianlubiaozibiaozbh: TIntegerField
      FieldName = 'zbh'
    end
    object xianlubiaozibiaojlqszgls: TWideStringField
      FieldName = 'jlqszgls'
      Size = 50
    end
    object xianlubiaozibiaozplj: TWideStringField
      FieldName = 'zplj'
      Size = 100
    end
  end
  object DataSetProvider12: TDataSetProvider
    DataSet = FDQuery12
    Left = 360
    Top = 440
  end
  object FDQuery12: TFDQuery
    Connection = FDConnection2
    SQL.Strings = (
      'select * from sj_user')
    Left = 456
    Top = 440
  end
  object sijiyonghu: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'DataSetProvider12'
    Left = 536
    Top = 440
    object sijiyonghuid: TAutoIncField
      FieldName = 'id'
      ReadOnly = True
    end
    object sijiyonghuyhm: TWideStringField
      FieldName = 'yhm'
      Size = 50
    end
    object sijiyonghuyhmm: TWideStringField
      FieldName = 'yhmm'
      Size = 50
    end
    object sijiyonghuyhzt: TWideStringField
      FieldName = 'yhzt'
    end
    object sijiyonghuyzm: TWideStringField
      FieldName = 'yzm'
    end
    object sijiyonghubz: TWideStringField
      FieldName = 'bz'
      Size = 100
    end
    object sijiyonghusj: TDateField
      FieldName = 'sj'
    end
    object sijiyonghucs: TWideStringField
      FieldName = 'cs'
      Required = True
      Size = 50
    end
  end
  object yuepiao: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'DataSetProvider13'
    Left = 528
    Top = 520
    object yuepiaoid: TAutoIncField
      FieldName = 'id'
      ReadOnly = True
    end
    object yuepiaoyhm: TWideStringField
      FieldName = 'yhm'
      Size = 50
    end
    object yuepiaogmsj: TWideStringField
      FieldName = 'gmsj'
      Size = 50
    end
    object yuepiaogmxl: TWideStringField
      FieldName = 'gmxl'
      Size = 50
    end
    object yuepiaogmyf: TWideStringField
      FieldName = 'gmyf'
      Size = 50
    end
    object yuepiaogmnf: TWideStringField
      FieldName = 'gmnf'
      Size = 50
    end
    object yuepiaogmqsz: TWideStringField
      FieldName = 'gmqsz'
      Size = 50
    end
    object yuepiaogmzdz: TWideStringField
      FieldName = 'gmzdz'
      Size = 50
    end
    object yuepiaocp: TWideStringField
      FieldName = 'cp'
      Size = 50
    end
    object yuepiaoscsj: TWideStringField
      FieldName = 'scsj'
      Size = 50
    end
    object yuepiaoxcsj: TWideStringField
      FieldName = 'xcsj'
      Size = 50
    end
    object yuepiaoypzt: TWideStringField
      FieldName = 'ypzt'
      Size = 50
    end
  end
  object FDQuery13: TFDQuery
    Connection = FDConnection2
    SQL.Strings = (
      'select * from yuepiao')
    Left = 448
    Top = 520
  end
  object DataSetProvider13: TDataSetProvider
    DataSet = FDQuery13
    Left = 352
    Top = 520
  end
  object DataSetProvider14: TDataSetProvider
    DataSet = FDQuery14
    Left = 352
    Top = 584
  end
  object FDQuery14: TFDQuery
    Connection = FDConnection2
    SQL.Strings = (
      'select * from  xianlubiaozibiao')
    Left = 448
    Top = 584
  end
  object piaojia: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'DataSetProvider14'
    Left = 528
    Top = 584
    object piaojiaid: TAutoIncField
      FieldName = 'id'
      ReadOnly = True
    end
    object piaojiaxlbh: TWideStringField
      FieldName = 'xlbh'
      Size = 50
    end
    object piaojiazmc: TWideStringField
      FieldName = 'zmc'
      Size = 50
    end
    object piaojiajd: TWideStringField
      FieldName = 'jd'
      Size = 50
    end
    object piaojiawd: TWideStringField
      FieldName = 'wd'
      Size = 50
    end
    object piaojiadzsj: TWideStringField
      FieldName = 'dzsj'
      Size = 50
    end
    object piaojiabz: TWideStringField
      FieldName = 'bz'
      Size = 50
    end
    object piaojiajlqszgls: TWideStringField
      FieldName = 'jlqszgls'
      Size = 50
    end
  end
  object DataSetProvider15: TDataSetProvider
    DataSet = FDQuery15
    Left = 848
    Top = 48
  end
  object FDQuery15: TFDQuery
    Connection = FDConnection2
    SQL.Strings = (
      'select * from  chengben')
    Left = 944
    Top = 48
  end
  object chengben: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'DataSetProvider15'
    Left = 1024
    Top = 48
    object chengbenid: TAutoIncField
      FieldName = 'id'
      ReadOnly = True
    end
    object chengbenhsdw: TWideStringField
      FieldName = 'hsdw'
      Size = 50
    end
    object chengbencbj: TWideStringField
      FieldName = 'cbj'
      Size = 50
    end
  end
  object QRY1: TFDQuery
    Connection = FDConnection2
    Left = 768
    Top = 488
  end
  object QRY2: TFDQuery
    Connection = FDConnection2
    Left = 768
    Top = 544
  end
  object QRY3: TFDQuery
    Connection = FDConnection2
    Left = 768
    Top = 616
  end
  object qry4: TFDQuery
    Connection = FDConnection2
    Left = 824
    Top = 544
  end
  object qry5: TFDQuery
    Connection = FDConnection2
    Left = 824
    Top = 616
  end
  object qry6: TFDQuery
    Connection = FDConnection2
    Left = 872
    Top = 544
  end
  object qry7: TFDQuery
    Connection = FDConnection2
    Left = 872
    Top = 616
  end
  object DataSetProvider16: TDataSetProvider
    DataSet = FDQuery16
    Left = 840
    Top = 112
  end
  object FDQuery16: TFDQuery
    Connection = FDConnection2
    SQL.Strings = (
      'select * from  trajectory')
    Left = 936
    Top = 112
  end
  object logweizhi: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'DataSetProvider16'
    Left = 1016
    Top = 112
    object logweizhitrj_id: TAutoIncField
      FieldName = 'trj_id'
      ReadOnly = True
    end
    object logweizhisch_id: TIntegerField
      FieldName = 'sch_id'
    end
    object logweizhilonglat_gd: TStringField
      FieldName = 'longlat_gd'
      Size = 510
    end
    object logweizhiline_time: TStringField
      FieldName = 'line_time'
      Size = 510
    end
    object logweizhiremark: TStringField
      FieldName = 'remark'
      Size = 510
    end
    object logweizhitel: TStringField
      FieldName = 'tel'
      Size = 510
    end
  end
  object DataSetProvider17: TDataSetProvider
    DataSet = FDQuery17
    Left = 832
    Top = 184
  end
  object FDQuery17: TFDQuery
    Connection = FDConnection2
    SQL.Strings = (
      'select * from  tuipiao where 1=2')
    Left = 928
    Top = 184
  end
  object tuipiao: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'DataSetProvider17'
    Left = 1008
    Top = 184
    object tuipiaoid: TAutoIncField
      FieldName = 'id'
      ReadOnly = True
    end
    object tuipiaotpbh: TIntegerField
      FieldName = 'tpbh'
    end
    object tuipiaotpxl: TWideStringField
      FieldName = 'tpxl'
      Size = 50
    end
    object tuipiaotpyy: TWideStringField
      FieldName = 'tpyy'
      Size = 50
    end
    object tuipiaotpje: TWideStringField
      FieldName = 'tpje'
      Size = 50
    end
    object tuipiaotprq: TSQLTimeStampField
      FieldName = 'tprq'
    end
  end
  object DataSetProvider18: TDataSetProvider
    DataSet = FDQuery18
    Left = 816
    Top = 264
  end
  object FDQuery18: TFDQuery
    Connection = FDConnection2
    SQL.Strings = (
      'select * from car_sch')
    Left = 912
    Top = 264
  end
  object fache: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'DataSetProvider18'
    Left = 992
    Top = 264
    object fachesch_id: TAutoIncField
      FieldName = 'sch_id'
      ReadOnly = True
    end
    object facheday: TDateField
      FieldName = 'day'
    end
    object facheplate: TStringField
      FieldName = 'plate'
      Size = 100
    end
    object fachedriver_id: TIntegerField
      FieldName = 'driver_id'
    end
    object facheline_id: TIntegerField
      FieldName = 'line_id'
    end
    object fachedepart_time: TStringField
      FieldName = 'depart_time'
      Size = 40
    end
    object facheinterpreter: TStringField
      FieldName = 'interpreter'
      Size = 100
    end
    object fachecheckman: TStringField
      FieldName = 'checkman'
      Size = 100
    end
    object fachescroll: TBooleanField
      FieldName = 'scroll'
    end
    object fachecity: TIntegerField
      FieldName = 'city'
    end
    object fachereal_depart_time: TStringField
      FieldName = 'real_depart_time'
      Size = 40
    end
    object fachereal_depart_lnglat: TStringField
      FieldName = 'real_depart_lnglat'
      Size = 510
    end
    object fachereal_end_time: TStringField
      FieldName = 'real_end_time'
      Size = 40
    end
    object fachereal_end_lnglat: TStringField
      FieldName = 'real_end_lnglat'
      Size = 510
    end
    object fachedepart_status: TIntegerField
      FieldName = 'depart_status'
    end
    object facheend_status: TIntegerField
      FieldName = 'end_status'
    end
    object fachesurplus_seat: TByteField
      FieldName = 'surplus_seat'
    end
    object fachelock_seat: TByteField
      FieldName = 'lock_seat'
    end
    object fachetotal_seat: TByteField
      FieldName = 'total_seat'
    end
    object facheremark: TStringField
      FieldName = 'remark'
      Size = 510
    end
    object fachestatus: TBooleanField
      FieldName = 'status'
    end
    object fachestate: TStringField
      FieldName = 'state'
      Size = 510
    end
    object facheinter_depart_time: TStringField
      FieldName = 'inter_depart_time'
      Size = 40
    end
    object facheinter_end_time: TStringField
      FieldName = 'inter_end_time'
      Size = 40
    end
    object fachedepart_inter_status: TIntegerField
      FieldName = 'depart_inter_status'
    end
    object facheend_inter_status: TIntegerField
      FieldName = 'end_inter_status'
    end
    object fachereal_depart_lnglat_jj: TStringField
      FieldName = 'real_depart_lnglat_jj'
      Size = 510
    end
    object fachereal_end_lnglat_jj: TStringField
      FieldName = 'real_end_lnglat_jj'
      Size = 510
    end
  end
  object DataSetProvider19: TDataSetProvider
    DataSet = FDQuery19
    Left = 808
    Top = 328
  end
  object FDQuery19: TFDQuery
    Connection = FDConnection2
    SQL.Strings = (
      'select * from cheliang')
    Left = 904
    Top = 328
  end
  object cheliang: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'DataSetProvider19'
    Left = 984
    Top = 328
    object cheliangid: TAutoIncField
      FieldName = 'id'
      ReadOnly = True
    end
    object cheliangcp: TWideStringField
      FieldName = 'cp'
      Size = 50
    end
    object cheliangsj: TWideStringField
      FieldName = 'sj'
      Size = 50
    end
    object cheliangxl: TWideStringField
      FieldName = 'xl'
      Size = 50
    end
    object cheliangmzrs: TWideStringField
      FieldName = 'mzrs'
      Size = 50
    end
  end
  object DataSetProvider20: TDataSetProvider
    DataSet = FDQuery20
    Left = 808
    Top = 400
  end
  object FDQuery20: TFDQuery
    Connection = FDConnection2
    SQL.Strings = (
      
        'select b.* from dbo.xianlubiao a left join  dbo.xianlubiaozibiao' +
        ' b on a.xlbh=b.xlbh'
      '')
    Left = 904
    Top = 400
  end
  object getchezhan: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'DataSetProvider20'
    Left = 984
    Top = 400
    object getchezhanid: TAutoIncField
      FieldName = 'id'
      ReadOnly = True
    end
    object getchezhanxlbh: TWideStringField
      FieldName = 'xlbh'
      Size = 50
    end
    object getchezhanzbh: TIntegerField
      FieldName = 'zbh'
    end
    object getchezhanzmc: TWideStringField
      FieldName = 'zmc'
      Size = 50
    end
    object getchezhanjd: TWideStringField
      FieldName = 'jd'
      Size = 50
    end
    object getchezhanwd: TWideStringField
      FieldName = 'wd'
      Size = 50
    end
    object getchezhandzsj: TWideStringField
      FieldName = 'dzsj'
      Size = 50
    end
    object getchezhanbz: TWideStringField
      FieldName = 'bz'
      Size = 50
    end
    object getchezhanjlqszgls: TWideStringField
      FieldName = 'jlqszgls'
      Size = 50
    end
  end
  object DataSetProvider21: TDataSetProvider
    DataSet = FDQuery21
    Left = 1136
    Top = 48
  end
  object FDQuery21: TFDQuery
    Connection = FDConnection2
    SQL.Strings = (
      
        'select aa.*,bb.yupiao from (select a.*,b.sjh from  dbo.xianlubia' +
        'o a left join dbo.cheliang b on a.cph=b.cp where b.sjh='#39'15928412' +
        '080'#39') as aa left join'
      
        '  (select 0 as xuhao, b.ccsj,a.mzrs,a.xlbh,(a.mzrs-b.rs) as yupi' +
        'ao from  ( select mzrs,xlbh from  dbo.xianlubiao ) a left join '
      
        '   (SELECT ccsj,ch,COUNT(*) as rs FROM [dbo].[ck_chepiao]   wher' +
        'e ccsj=CONVERT(varchar(100), GETDATE(), 102) '
      
        '      and (ddzt='#39#24453#20056#36710#39' or ddzt='#39#24050#20056#36710#39' or ddzt='#39#24050#23436#25104#39') group by  ccs' +
        'j,ch) b on a.xlbh=b.ch ) as bb on aa.xlbh=bb.xlbh')
    Left = 1224
    Top = 48
  end
  object sjxl: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'DataSetProvider21'
    Left = 1280
    Top = 48
    object sjxlid: TAutoIncField
      FieldName = 'id'
      ReadOnly = True
    end
    object sjxlxlbh: TWideStringField
      FieldName = 'xlbh'
      Size = 50
    end
    object sjxlxlmc: TWideStringField
      FieldName = 'xlmc'
      Size = 50
    end
    object sjxlxlqsz: TWideStringField
      FieldName = 'xlqsz'
      Size = 50
    end
    object sjxlxlzdz: TWideStringField
      FieldName = 'xlzdz'
      Size = 50
    end
    object sjxlxljg: TWideStringField
      FieldName = 'xljg'
    end
    object sjxlfcsj: TWideStringField
      FieldName = 'fcsj'
      Size = 50
    end
    object sjxlddsj: TWideStringField
      FieldName = 'ddsj'
      Size = 50
    end
    object sjxlxlpj: TWideStringField
      FieldName = 'xlpj'
      Size = 50
    end
    object sjxlsfqyxlpj: TWideStringField
      FieldName = 'sfqyxlpj'
      Size = 50
    end
    object sjxlmzrs: TWideStringField
      FieldName = 'mzrs'
      Size = 50
    end
    object sjxlcph: TWideStringField
      FieldName = 'cph'
      Size = 50
    end
    object sjxlclzt: TWideStringField
      FieldName = 'clzt'
      Size = 50
    end
    object sjxlcs: TWideStringField
      FieldName = 'cs'
      Size = 50
    end
    object sjxlsjh: TWideStringField
      FieldName = 'sjh'
      Size = 50
    end
    object sjxltype: TWideStringField
      FieldName = 'type'
      Size = 50
    end
    object sjxlstatus: TBooleanField
      FieldName = 'status'
      Required = True
    end
    object sjxlsjxltc: TWideStringField
      FieldName = 'sjxltc'
      Size = 50
    end
    object sjxlxljjy: TWideStringField
      FieldName = 'xljjy'
      Size = 50
    end
    object sjxljjytc: TWideStringField
      FieldName = 'jjytc'
      Size = 50
    end
    object sjxlis_sell: TBooleanField
      FieldName = 'is_sell'
      Required = True
    end
    object sjxlsell_way: TWideStringField
      FieldName = 'sell_way'
      Size = 200
    end
    object sjxlsfsm: TWideStringField
      FieldName = 'sfsm'
      Required = True
      Size = 10
    end
    object sjxlstart_sell_date: TDateField
      FieldName = 'start_sell_date'
    end
    object sjxlorderStr: TIntegerField
      FieldName = 'orderStr'
      Required = True
    end
    object sjxlyupiao: TIntegerField
      FieldName = 'yupiao'
      ReadOnly = True
    end
  end
  object duotiao: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'DataSetProvider22'
    Left = 1312
    Top = 112
    object duotiaoid: TAutoIncField
      FieldName = 'id'
      ReadOnly = True
    end
    object duotiaoxlbh: TWideStringField
      FieldName = 'xlbh'
      Size = 50
    end
    object duotiaoxlmc: TWideStringField
      FieldName = 'xlmc'
      Size = 50
    end
    object duotiaoxlqsz: TWideStringField
      FieldName = 'xlqsz'
      Size = 50
    end
    object duotiaoxlzdz: TWideStringField
      FieldName = 'xlzdz'
      Size = 50
    end
    object duotiaoxljg: TWideStringField
      FieldName = 'xljg'
    end
    object duotiaofcsj: TWideStringField
      FieldName = 'fcsj'
      Size = 50
    end
    object duotiaoddsj: TWideStringField
      FieldName = 'ddsj'
      Size = 50
    end
    object duotiaoxlpj: TWideStringField
      FieldName = 'xlpj'
      Size = 50
    end
    object duotiaosfqyxlpj: TWideStringField
      FieldName = 'sfqyxlpj'
      Size = 50
    end
    object duotiaomzrs: TWideStringField
      FieldName = 'mzrs'
      Size = 50
    end
    object duotiaocph: TWideStringField
      FieldName = 'cph'
      Size = 50
    end
    object duotiaoclzt: TWideStringField
      FieldName = 'clzt'
      Size = 50
    end
    object duotiaocs: TWideStringField
      FieldName = 'cs'
      Size = 50
    end
  end
  object FDQuery22: TFDQuery
    Connection = FDConnection2
    SQL.Strings = (
      'select  * from  dbo.xianlubiao ')
    Left = 1232
    Top = 112
  end
  object DataSetProvider22: TDataSetProvider
    DataSet = FDQuery22
    Left = 1144
    Top = 112
  end
  object DataSetProvider23: TDataSetProvider
    DataSet = FDQuery23
    Left = 1136
    Top = 192
  end
  object FDQuery23: TFDQuery
    Connection = FDConnection2
    SQL.Strings = (
      'select  * from  dbo.renshu')
    Left = 1224
    Top = 192
  end
  object renshu: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'DataSetProvider23'
    Left = 1304
    Top = 192
    object renshuid: TAutoIncField
      FieldName = 'id'
      ReadOnly = True
    end
    object renshuchrq: TWideStringField
      FieldName = 'chrq'
      Size = 50
    end
    object renshuxl: TWideStringField
      FieldName = 'xl'
      Size = 50
    end
    object renshuzbh: TWideStringField
      FieldName = 'zbh'
      Size = 50
    end
    object renshuzm: TWideStringField
      FieldName = 'zm'
      Size = 50
    end
    object renshurs: TWideStringField
      FieldName = 'rs'
      Size = 50
    end
  end
  object qry8: TFDQuery
    Connection = FDConnection2
    Left = 920
    Top = 544
  end
  object qry9: TFDQuery
    Connection = FDConnection2
    Left = 920
    Top = 616
  end
  object qry10: TFDQuery
    Connection = FDConnection2
    Left = 968
    Top = 544
  end
  object Timer1: TTimer
    Interval = 86400000
    OnTimer = Timer1Timer
    Left = 969
    Top = 616
  end
  object DataSetProvider24: TDataSetProvider
    DataSet = FDQuery24
    Left = 1136
    Top = 264
  end
  object FDQuery24: TFDQuery
    Connection = FDConnection2
    SQL.Strings = (
      
        'select a.*,b.csmc from zqchepiao a left join chegnshi b on a.cs=' +
        'b.csbh')
    Left = 1224
    Top = 264
  end
  object zqchepiao: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'DataSetProvider24'
    Left = 1304
    Top = 264
    object zqchepiaoid: TAutoIncField
      FieldName = 'id'
      ReadOnly = True
    end
    object zqchepiaoxl: TWideStringField
      FieldName = 'xl'
      Size = 50
    end
    object zqchepiaogmrq: TWideStringField
      FieldName = 'gmrq'
      Size = 50
    end
    object zqchepiaogmje: TWideStringField
      FieldName = 'gmje'
      Size = 50
    end
    object zqchepiaodqrq: TWideStringField
      FieldName = 'dqrq'
      Size = 50
    end
    object zqchepiaocpzt: TWideStringField
      FieldName = 'cpzt'
      Size = 50
    end
    object zqchepiaocplx: TWideStringField
      FieldName = 'cplx'
      Size = 50
    end
    object zqchepiaoyhm: TWideStringField
      FieldName = 'yhm'
      Size = 50
    end
    object zqchepiaocs: TWideStringField
      FieldName = 'cs'
      Size = 50
    end
    object zqchepiaoqsrq: TWideStringField
      FieldName = 'qsrq'
      Size = 50
    end
    object zqchepiaoorder_id: TIntegerField
      FieldName = 'order_id'
    end
    object zqchepiaocsmc: TWideStringField
      FieldName = 'csmc'
      Size = 50
    end
  end
  object DataSetProvider25: TDataSetProvider
    DataSet = FDQuery25
    Left = 1120
    Top = 336
  end
  object FDQuery25: TFDQuery
    Connection = FDConnection2
    SQL.Strings = (
      'select  * from  shengji')
    Left = 1208
    Top = 336
  end
  object shengji: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'DataSetProvider25'
    Left = 1288
    Top = 336
    object shengjiid: TAutoIncField
      FieldName = 'id'
      ReadOnly = True
    end
    object shengjibanben: TStringField
      FieldName = 'banben'
      Size = 510
    end
  end
  object DataSetProvider26: TDataSetProvider
    DataSet = FDQuery26
    Left = 1128
    Top = 408
  end
  object FDQuery26: TFDQuery
    Connection = FDConnection2
    SQL.Strings = (
      'select  * from  kaleixing')
    Left = 1216
    Top = 408
  end
  object kaleixing: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'DataSetProvider26'
    Left = 1296
    Top = 408
    object kaleixingid: TAutoIncField
      FieldName = 'id'
      ReadOnly = True
    end
    object kaleixingchengshi: TWideStringField
      FieldName = 'chengshi'
      Size = 50
    end
    object kaleixingzhouqi: TWideStringField
      FieldName = 'zhouqi'
      Size = 50
    end
    object kaleixingjiage: TWideStringField
      FieldName = 'jiage'
      Size = 50
    end
    object kaleixingtianshu: TWideStringField
      FieldName = 'tianshu'
      Size = 50
    end
  end
  object DataSetProvider27: TDataSetProvider
    DataSet = FDQuery27
    Left = 1128
    Top = 480
  end
  object FDQuery27: TFDQuery
    Connection = FDConnection2
    SQL.Strings = (
      'select  * from  driver_log where 1=2')
    Left = 1216
    Top = 480
  end
  object sijilog: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'DataSetProvider27'
    Left = 1296
    Top = 480
    object sijilogid: TAutoIncField
      FieldName = 'id'
      ReadOnly = True
    end
    object sijilogdriverid: TIntegerField
      FieldName = 'driverid'
    end
    object sijilogwrk_time: TStringField
      FieldName = 'wrk_time'
      Size = 255
    end
    object sijilogsch_id: TIntegerField
      FieldName = 'sch_id'
    end
    object sijilogremark: TStringField
      FieldName = 'remark'
      Size = 255
    end
    object sijilogreward: TStringField
      FieldName = 'reward'
      Size = 510
    end
  end
  object DataSetProvider28: TDataSetProvider
    DataSet = FDQuery28
    Left = 1112
    Top = 544
  end
  object FDQuery28: TFDQuery
    Connection = FDConnection2
    SQL.Strings = (
      'select  * from  jjylog  where 1=2')
    Left = 1200
    Top = 544
  end
  object jjylog: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'DataSetProvider28'
    Left = 1280
    Top = 544
    object jjylogid: TAutoIncField
      FieldName = 'id'
      ReadOnly = True
    end
    object jjylogcph: TWideStringField
      FieldName = 'cph'
      Size = 50
    end
    object jjylogriqi: TWideStringField
      FieldName = 'riqi'
      Size = 50
    end
    object jjylogjjy: TWideStringField
      FieldName = 'jjy'
      Size = 50
    end
    object jjylogxlbh: TWideStringField
      FieldName = 'xlbh'
      Size = 50
    end
    object jjylogjjytc: TWideStringField
      FieldName = 'jjytc'
      Size = 50
    end
  end
  object DataSetProvider29: TDataSetProvider
    DataSet = FDQuery29
    Left = 1104
    Top = 616
  end
  object FDQuery29: TFDQuery
    Connection = FDConnection2
    SQL.Strings = (
      'select  * from  fuwupingjia where 1=2')
    Left = 1192
    Top = 616
  end
  object sjfwpj: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'DataSetProvider29'
    Left = 1272
    Top = 616
    object sjfwpjid: TAutoIncField
      FieldName = 'id'
      ReadOnly = True
    end
    object sjfwpjpj: TWideStringField
      FieldName = 'pj'
      Size = 50
    end
    object sjfwpjpjnr: TWideStringField
      FieldName = 'pjnr'
      Size = 50
    end
    object sjfwpjxl: TWideStringField
      FieldName = 'xl'
      Size = 50
    end
    object sjfwpjsjdh: TWideStringField
      FieldName = 'sjdh'
      Size = 50
    end
    object sjfwpjsjxm: TWideStringField
      FieldName = 'sjxm'
      Size = 50
    end
    object sjfwpjpjr: TWideStringField
      FieldName = 'pjr'
      Size = 50
    end
    object sjfwpjrq: TSQLTimeStampField
      FieldName = 'rq'
    end
  end
  object DataSetProvider30: TDataSetProvider
    DataSet = FDQuery30
    Left = 32
    Top = 672
  end
  object FDQuery30: TFDQuery
    Connection = FDConnection2
    SQL.Strings = (
      'select  * from  station where 1=2')
    Left = 120
    Top = 672
  end
  object tousu: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'DataSetProvider30'
    Left = 200
    Top = 672
    object tousust_id: TAutoIncField
      FieldName = 'st_id'
      ReadOnly = True
    end
    object tousustation_name: TStringField
      FieldName = 'station_name'
      Size = 50
    end
    object tousushort_name: TStringField
      FieldName = 'short_name'
      Size = 10
    end
    object tousulonglat_bd: TStringField
      FieldName = 'longlat_bd'
      Size = 255
    end
    object tousulonglat_gd: TStringField
      FieldName = 'longlat_gd'
      Size = 255
    end
    object tousuradius: TIntegerField
      FieldName = 'radius'
    end
    object tousucity: TIntegerField
      FieldName = 'city'
    end
    object tousuaddress: TStringField
      FieldName = 'address'
      Size = 255
    end
    object toususign_img: TStringField
      FieldName = 'sign_img'
      Size = 255
    end
  end
  object FDConnection3: TFDConnection
    Params.Strings = (
      'Database=cdztc'
      'User_Name=root'
      'Password=Wjzh2019'
      'Server=110.185.107.182'
      'CharacterSet=gbk'
      'DriverID=MySQL')
    LoginPrompt = False
    Left = 560
    Top = 32
  end
  object FDQuery31: TFDQuery
    Connection = FDConnection3
    Left = 560
    Top = 96
  end
  object FDQuery32: TFDQuery
    Connection = FDConnection3
    Left = 640
    Top = 96
  end
  object DataSetProvider31: TDataSetProvider
    DataSet = FDQuery33
    Left = 344
    Top = 680
  end
  object FDQuery33: TFDQuery
    Connection = FDConnection2
    SQL.Strings = (
      'select  * from  uid_log where 1=2')
    Left = 432
    Top = 680
  end
  object ClientDataSet4: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'DataSetProvider31'
    Left = 512
    Top = 680
    object ClientDataSet4id: TAutoIncField
      FieldName = 'id'
      ReadOnly = True
    end
    object ClientDataSet4dr_id: TStringField
      FieldName = 'dr_id'
      Size = 510
    end
    object ClientDataSet4dr_name: TStringField
      FieldName = 'dr_name'
      Size = 510
    end
    object ClientDataSet4uid: TStringField
      FieldName = 'uid'
      Size = 510
    end
    object ClientDataSet4up_time: TStringField
      FieldName = 'up_time'
      Size = 510
    end
  end
  object DataSetProvider32: TDataSetProvider
    DataSet = FDQuery34
    Left = 40
    Top = 736
  end
  object FDQuery34: TFDQuery
    Connection = FDConnection2
    SQL.Strings = (
      'select * from interpreter where 1=2')
    Left = 120
    Top = 736
  end
  object ClientDataSet5: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'DataSetProvider32'
    Left = 200
    Top = 736
    object ClientDataSet5in_id: TAutoIncField
      FieldName = 'in_id'
      ReadOnly = True
    end
    object ClientDataSet5in_name: TStringField
      FieldName = 'in_name'
      Size = 100
    end
    object ClientDataSet5openid: TStringField
      FieldName = 'openid'
      Size = 60
    end
    object ClientDataSet5phone: TStringField
      FieldName = 'phone'
      Size = 100
    end
    object ClientDataSet5password: TStringField
      FieldName = 'password'
      Size = 510
    end
    object ClientDataSet5company_id: TShortintField
      FieldName = 'company_id'
    end
    object ClientDataSet5city: TIntegerField
      FieldName = 'city'
    end
    object ClientDataSet5add_time: TDateTimeField
      FieldName = 'add_time'
    end
    object ClientDataSet5salary: TBCDField
      FieldName = 'salary'
      Precision = 10
      Size = 2
    end
    object ClientDataSet5img: TStringField
      FieldName = 'img'
      Size = 510
    end
    object ClientDataSet5uid: TStringField
      FieldName = 'uid'
      Size = 510
    end
  end
  object DataSetProvider33: TDataSetProvider
    DataSet = FDQuery35
    Left = 624
    Top = 680
  end
  object FDQuery35: TFDQuery
    Connection = FDConnection2
    SQL.Strings = (
      'select  * from interpreter_log where 1=2')
    Left = 712
    Top = 680
  end
  object ClientDataSet6: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'DataSetProvider33'
    Left = 792
    Top = 680
    object ClientDataSet6id: TAutoIncField
      FieldName = 'id'
      ReadOnly = True
    end
    object ClientDataSet6inter_id: TIntegerField
      FieldName = 'inter_id'
    end
    object ClientDataSet6wrk_time: TStringField
      FieldName = 'wrk_time'
      Size = 510
    end
    object ClientDataSet6sch_id: TIntegerField
      FieldName = 'sch_id'
    end
    object ClientDataSet6reward: TBCDField
      FieldName = 'reward'
      Precision = 10
      Size = 2
    end
    object ClientDataSet6remark: TStringField
      FieldName = 'remark'
      Size = 510
    end
  end
  object DataSetProvider34: TDataSetProvider
    DataSet = FDQuery36
    Left = 608
    Top = 752
  end
  object FDQuery36: TFDQuery
    Connection = FDConnection2
    SQL.Strings = (
      'select  * from checknumber where 1=2')
    Left = 696
    Top = 752
  end
  object ClientDataSet7: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'DataSetProvider34'
    Left = 776
    Top = 752
    object ClientDataSet7checkdate: TSQLTimeStampField
      FieldName = 'checkdate'
    end
    object ClientDataSet7number: TStringField
      FieldName = 'number'
      Size = 200
    end
    object ClientDataSet7sch_id: TStringField
      FieldName = 'sch_id'
      Size = 200
    end
    object ClientDataSet7id: TAutoIncField
      FieldName = 'id'
      ReadOnly = True
    end
  end
  object ClientDataSet8: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'DataSetProvider35'
    Left = 1232
    Top = 696
    object ClientDataSet8id: TAutoIncField
      FieldName = 'id'
      ReadOnly = True
    end
    object ClientDataSet8coupon_code: TStringField
      FieldName = 'coupon_code'
      Size = 510
    end
    object ClientDataSet8coupon_code_status: TIntegerField
      FieldName = 'coupon_code_status'
    end
    object ClientDataSet8use_time: TDateTimeField
      FieldName = 'use_time'
    end
    object ClientDataSet8name: TStringField
      FieldName = 'name'
      Size = 60
    end
    object ClientDataSet8idcard: TStringField
      FieldName = 'idcard'
      Size = 60
    end
    object ClientDataSet8travellerlist: TStringField
      FieldName = 'travellerlist'
      Size = 510
    end
    object ClientDataSet8order_number: TStringField
      FieldName = 'order_number'
      Size = 60
    end
    object ClientDataSet8refund_time: TDateTimeField
      FieldName = 'refund_time'
    end
    object ClientDataSet8order_detail_id: TIntegerField
      FieldName = 'order_detail_id'
      Required = True
    end
    object ClientDataSet8switch: TIntegerField
      FieldName = 'switch'
    end
    object ClientDataSet8status: TIntegerField
      FieldName = 'status'
    end
    object ClientDataSet8tel: TStringField
      FieldName = 'tel'
      Size = 510
    end
    object ClientDataSet8is_exchange: TIntegerField
      FieldName = 'is_exchange'
    end
    object ClientDataSet8refound_number: TStringField
      FieldName = 'refound_number'
      Size = 200
    end
    object ClientDataSet8update_user_id: TIntegerField
      FieldName = 'update_user_id'
    end
    object ClientDataSet8refund_money: TSingleField
      FieldName = 'refund_money'
    end
    object ClientDataSet8coupon_code_url: TStringField
      FieldName = 'coupon_code_url'
      Size = 510
    end
    object ClientDataSet8real_ticket_number: TStringField
      FieldName = 'real_ticket_number'
      Size = 510
    end
    object ClientDataSet8remark: TStringField
      FieldName = 'remark'
      Size = 510
    end
    object ClientDataSet8code_number: TIntegerField
      FieldName = 'code_number'
    end
  end
  object FDQuery37: TFDQuery
    Connection = FDConnection3
    SQL.Strings = (
      'select  * from order_coupon_code where 1=2')
    Left = 1152
    Top = 696
  end
  object DataSetProvider35: TDataSetProvider
    DataSet = FDQuery37
    Left = 1064
    Top = 696
  end
  object FDQuery38: TFDQuery
    Connection = FDConnection3
    SQL.Strings = (
      'select  * from order_coupon_code where 1=2')
    Left = 920
    Top = 744
  end
  object FDQuery39: TFDQuery
    Connection = FDConnection3
    SQL.Strings = (
      'select  * from order_coupon_code where 1=2')
    Left = 984
    Top = 752
  end
  object ClientDataSet9: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'DataSetProvider36'
    Left = 1240
    Top = 760
    object ClientDataSet9line_name: TStringField
      FieldName = 'line_name'
      Size = 510
    end
    object ClientDataSet9start: TIntegerField
      FieldName = 'start'
    end
    object ClientDataSet9end: TIntegerField
      FieldName = 'end'
    end
    object ClientDataSet9city: TIntegerField
      FieldName = 'city'
    end
    object ClientDataSet9reward: TBCDField
      FieldName = 'reward'
      Precision = 10
      Size = 2
    end
    object ClientDataSet9inter_reward: TBCDField
      FieldName = 'inter_reward'
      Precision = 10
      Size = 2
    end
    object ClientDataSet9station_id: TLongWordField
      FieldName = 'station_id'
    end
    object ClientDataSet9starstation_name: TStringField
      FieldName = 'starstation_name'
      Size = 100
    end
    object ClientDataSet9starlonglat_gd: TStringField
      FieldName = 'starlonglat_gd'
      Size = 510
    end
    object ClientDataSet9starlonglat_bd: TStringField
      FieldName = 'starlonglat_bd'
      Size = 510
    end
    object ClientDataSet9starradius: TIntegerField
      FieldName = 'starradius'
    end
    object ClientDataSet9endstation_name: TStringField
      FieldName = 'endstation_name'
      Size = 100
    end
    object ClientDataSet9endlonglat_gd: TStringField
      FieldName = 'endlonglat_gd'
      Size = 510
    end
    object ClientDataSet9endlonglat_bd: TStringField
      FieldName = 'endlonglat_bd'
      Size = 510
    end
    object ClientDataSet9endradius: TIntegerField
      FieldName = 'endradius'
    end
    object ClientDataSet9zjstation_name: TStringField
      FieldName = 'zjstation_name'
      Size = 100
    end
    object ClientDataSet9zjlonglat_gd: TStringField
      FieldName = 'zjlonglat_gd'
      Size = 510
    end
    object ClientDataSet9zjlonglat_bd: TStringField
      FieldName = 'zjlonglat_bd'
      Size = 510
    end
    object ClientDataSet9zjradius: TIntegerField
      FieldName = 'zjradius'
    end
  end
  object FDQuery40: TFDQuery
    Connection = FDConnection2
    SQL.Strings = (
      
        'select aaaa.*,bbbb.station_name as '#39'zjstation_name'#39',bbbb.longlat' +
        '_gd as '#39'zjlonglat_gd'#39',bbbb.longlat_bd as '#39'zjlonglat_bd'#39',bbbb.rad' +
        'ius as '#39'zjradius'#39
      
        ' from (select aaa.*,bbb.station_name as '#39'endstation_name'#39',bbb.lo' +
        'nglat_gd as '#39'endlonglat_gd'#39',bbb.longlat_bd as '#39'endlonglat_bd'#39',bb' +
        'b.radius as '#39'endradius'#39' '
      
        'from (select aa.*,bb.station_name as '#39'starstation_name'#39',bb.longl' +
        'at_gd as '#39'starlonglat_gd'#39',bb.longlat_bd as '#39'starlonglat_bd'#39',bb.r' +
        'adius as '#39'starradius'#39' from '
      
        '(select a.line_name,a.`start`,a.`end`,a.city,a.reward,a.inter_re' +
        'ward,b.station_id from line a LEFT JOIN line_station b on a.line' +
        '_id=b.line_id where a.line_id='#39'200'#39') aa'
      
        'LEFT JOIN station bb on aa.`start`=bb.st_id) aaa LEFT JOIN stati' +
        'on bbb on aaa.end=bbb.st_id) aaaa LEFT JOIN station bbbb on aaaa' +
        '.station_id=bbbb.st_id')
    Left = 1160
    Top = 760
  end
  object DataSetProvider36: TDataSetProvider
    DataSet = FDQuery40
    Left = 1072
    Top = 760
  end
end
